How to: Combine text and a field in a form's text box.
Solution:
In the Form Design view, use the 'Control Source' property box in the property sheet of the form to combine text and a field in a text box.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Click on the desired control in which to add text.
6) Select the 'View' menu and select 'Properties'.
7) Click the 'Data' tab.
8) Click on the 'Control Source' box. (A down arrow appears.)
9) Type the desired expression that combines the appropriate text and fields.
EXAMPLE: Combining text with fields
10) Select the 'File' menu and select 'Save' to save the form.
